SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW dbo.vwbCargosGenericos
AS
SELECT     dbo.tb_CargosGenericos.idCargoGenerico AS ID, dbo.tb_CargosGenericos.Descripcion, 
                      dbo.vwrNivelesEnsenanza.Descripcion AS NivelDeEnseñanza
FROM         dbo.tb_CargosGenericos INNER JOIN
                      dbo.vwrNivelesEnsenanza ON dbo.tb_CargosGenericos.Nivel = dbo.vwrNivelesEnsenanza.ID

GO
GRANT SELECT ON  [dbo].[vwbCargosGenericos] TO [Juntas]
GRANT SELECT ON  [dbo].[vwbCargosGenericos] TO [RegistroTitulos]
GRANT SELECT ON  [dbo].[vwbCargosGenericos] TO [SoloVer]
GO
